CREATE TABLE [dbo].[loopbaan] (
	[volgnr] [bigint] IDENTITY (1, 1) NOT NULL ,
	[inschrijvingsNr] [char] (7) NOT NULL ,
	[jaar] [char] (4) NULL ,
	[klas] [varchar] (5) NULL ,
	[vakcode] [char] (2) NULL ,
	[vakvolg] [char] (2) NULL ,
	[dw1] [int] NULL ,
	[ex1] [int] NULL ,
	[tot1] [int] NULL ,
	[dw2] [int] NULL ,
	[ex2] [int] NULL ,
	[tot2] [int] NULL ,
	[dw3] [int] NULL ,
	[ex3] [int] NULL ,
	[tot3] [int] NULL ,
	[dw4] [int] NULL ,
	[ex4] [int] NULL ,
	[tot4] [int] NULL ,
	CONSTRAINT [pk_loopbaan] PRIMARY KEY  CLUSTERED 
	(
		[volgnr]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] ,
	 UNIQUE  NONCLUSTERED 
	(
		[volgnr]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
 CREATE  INDEX [pk_loopbaan_inschrijvingsNr] ON [dbo].[loopbaan]([inschrijvingsNr]) WITH  FILLFACTOR = 90 ON [PRIMARY]
 CREATE  INDEX [pk_loopbaan_jaar] ON [dbo].[loopbaan]([jaar]) WITH  FILLFACTOR = 90 ON [PRIMARY]
 CREATE  INDEX [pk_loopbaan_vakCode] ON [dbo].[loopbaan]([vakcode]) WITH  FILLFACTOR = 90 ON [PRIMARY]